UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XYI0cL7cFzDy00G7d4bosKwjTmVBOTV7uBaZR+9Vd70='
WHERE
key_id = '5fa6cc27483e76e37374930a6a05d05997687c9bbb82e95ef63bc0e0b15a9f2c'
AND (
token = 'XYI0cL7cFzDy00G7d4bosKwjTmVBOTV7uBaZR+9Vd70='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)