UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OhSvlfNwYAMBlsDLqJE60wAmVwutBexN4OCUS0Z9z1k='
WHERE
key_id = 'ffd8a2f1444796f34993088d6f496a5fc8bd8fd27a3a8a3d60ec8f6338db771a'
AND (
token = 'OhSvlfNwYAMBlsDLqJE60wAmVwutBexN4OCUS0Z9z1k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)