UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r1A5tk6IT1tAIPZwqT2alXm129HqZpydSOgy0RJTsgE='
WHERE
key_id = '67743a7be34077caa2434c755ff2b983ac4503d863fb032e15b693e4ae7f7d9d'
AND (
token = 'r1A5tk6IT1tAIPZwqT2alXm129HqZpydSOgy0RJTsgE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)