UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hAE7K9LICrfq42aHBmn7SbvhytOM8DtpNXKk6C+D8n0='
WHERE
key_id = 'cd0f364cc2fdc2c39d02ee76d4420ee4772f5670de3ca3a38c793d2084383e6d'
AND (
token = 'hAE7K9LICrfq42aHBmn7SbvhytOM8DtpNXKk6C+D8n0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)