UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N8eNvjyf1DD+IKUKCQsj4j++ncbTBrTuIjFO9gOTJvI='
WHERE
key_id = 'acdbfcc74e1ecd3b51eb0c238adb0bf8387f93f0a5e49812adf16227f6c00adb'
AND (
token = 'N8eNvjyf1DD+IKUKCQsj4j++ncbTBrTuIjFO9gOTJvI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)