UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nLyRn/GeXPD89nOeBKaO/ciOtm4DEJDYztBVcW/AaIc='
WHERE
key_id = '78f702d8e62e06ee49275f74275f5bb99c2cbc810bcc7c22d8ab9b6714d5ab44'
AND (
token = 'nLyRn/GeXPD89nOeBKaO/ciOtm4DEJDYztBVcW/AaIc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)