UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vf4ixEJW3xdPY8OhcoAkCbOFPZmiHcZDdcKMFJMa1gM='
WHERE
key_id = '7d749bc12262ea597209fc994d321815d6eb552c7242b89a6171b262c255cc8d'
AND (
token = 'vf4ixEJW3xdPY8OhcoAkCbOFPZmiHcZDdcKMFJMa1gM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)