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