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