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