UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KHxVgOn4boK8XTlTljZ46IAe72vb4C4SofVfemBKmN8='
WHERE
key_id = '96c1bba3883fc7a893109f570c1cf5b4b11e52413c2b840ea21a289bf49a9318'
AND (
token = 'KHxVgOn4boK8XTlTljZ46IAe72vb4C4SofVfemBKmN8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)