UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZMReBbeEM8gd5B0KZnrJOj60aMTI9N7GuTkX31S7wAM='
WHERE
key_id = 'da783e33afed6b0d355c9301a44ff0d832d90955d1f2d2f1f20d398243052971'
AND (
token = 'ZMReBbeEM8gd5B0KZnrJOj60aMTI9N7GuTkX31S7wAM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)