UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xeSVFniPW3IxBHaRx4HlnH3hJMdxO+qWYJxor8HDvvs='
WHERE
key_id = '46b0a581beeafd49078be380c84501054de4c817e79a196c989f978863e8d81b'
AND (
token = 'xeSVFniPW3IxBHaRx4HlnH3hJMdxO+qWYJxor8HDvvs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)