UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MHWqBA3VdUjyFUbCfCfhA1lCRKeWUOt+YknffIH0Yd0='
WHERE
key_id = '4a75a2614c5184ae7d80afd400249439a54a46bbd24836f35b1662b84388379c'
AND (
token = 'MHWqBA3VdUjyFUbCfCfhA1lCRKeWUOt+YknffIH0Yd0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)