UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xbn/kkf7vStWbW7c96FC19rpPpJJCybI2fUWqOmI/t0='
WHERE
key_id = 'a40caa681d87c123ce5e9b7d20d25bccb52875072d824dca8f9503198f919085'
AND (
token = 'Xbn/kkf7vStWbW7c96FC19rpPpJJCybI2fUWqOmI/t0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)