UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '65XGMs26UjajCAm9bKNgC/Q9VlTkdJhJfAWt26uPMpA='
WHERE
key_id = '594313f4aa916fdb705407fd0ca9ec0d16663ff08d4e7d515f87090e92e3bd10'
AND (
token = '65XGMs26UjajCAm9bKNgC/Q9VlTkdJhJfAWt26uPMpA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)