UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Rmo4lHu9057LLTyNHWkwvvI+L/yI+DuwwjiqT6HeexA='
WHERE
key_id = 'ca55d2fcb04bb79ab5d8a8d9ca94c659a80be73970f72afd782aae052a0ca56f'
AND (
token = 'Rmo4lHu9057LLTyNHWkwvvI+L/yI+DuwwjiqT6HeexA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)