UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8pK1IdEuTwql5aLvTjihGYl1Fmpvkv7lPjyIlW0GOB8='
WHERE
key_id = '667794266e90af4aa5e63b942c0dcf4d07b964e630ad0b914bc2436d616448ec'
AND (
token = '8pK1IdEuTwql5aLvTjihGYl1Fmpvkv7lPjyIlW0GOB8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)