UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XStcHOX4MRfruqRhcC61WELnap/tALJMnChqUGFJ8cs='
WHERE
key_id = 'fb17f97dd3c2a18b92ecd83d13a29f7e3a720987d5241ec333ed8edc3ecf8b00'
AND (
token = 'XStcHOX4MRfruqRhcC61WELnap/tALJMnChqUGFJ8cs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)