UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'meZt3+keMfuykuPwnNK1YbZhu0DJjdp/4HU+cYbs2vI='
WHERE
key_id = '1aeb0fb9217597175eb0033e84a0b16a15a76bfa73c7b9ae44747c14ca70798e'
AND (
token = 'meZt3+keMfuykuPwnNK1YbZhu0DJjdp/4HU+cYbs2vI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)