UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rn3AHHO+oDv7Ay422vYTrS78JlsRRrgD9A/6rm94DbE='
WHERE
key_id = '3e5bd620b060f3440bb64bcf44e7d9bf36e116e075d0222236864e992472f66a'
AND (
token = 'rn3AHHO+oDv7Ay422vYTrS78JlsRRrgD9A/6rm94DbE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)