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