UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rdC/O1qi5eKHkKFVpygtOaVolIGZmSaDML/umLSBfd8='
WHERE
key_id = 'c58060c1ea769ad145b146f500b93f653cbc13b5a2a787ee2142cc5925e3a7a3'
AND (
token = 'rdC/O1qi5eKHkKFVpygtOaVolIGZmSaDML/umLSBfd8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)