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