UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CaALJz0yokq0SIQ67sZzk89FRsLHsNcAa/RoqsJmZSY='
WHERE
key_id = 'db37f007bd6d1075f7ec860ac45a28daf4580050135953ab8bc9d7e8c904e6f8'
AND (
token = 'CaALJz0yokq0SIQ67sZzk89FRsLHsNcAa/RoqsJmZSY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)