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