UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bSD84yGitmlXpI7GWxsE08p3sjCHFiCBT06cKSd8wno='
WHERE
key_id = 'de40a6cee3d30c22e97753a1e30446f7eea7b3a8ac282ba55c1cd287d9660a65'
AND (
token = 'bSD84yGitmlXpI7GWxsE08p3sjCHFiCBT06cKSd8wno='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)