UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3D+Jrz36aSh9kz1RnwOXcykTn9lToXGmzg0TAh0f/Hc='
WHERE
key_id = 'db4ece34763d4facdb6e6076f476cb7a48b233aeb513a071e95f27d6cfc50f1f'
AND (
token = '3D+Jrz36aSh9kz1RnwOXcykTn9lToXGmzg0TAh0f/Hc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)