UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/ktEQZNZPMiLQFMACOlLZbBLq59mSU8UZ51P3a+JXMc='
WHERE
key_id = '4a3a483c1e2946232b27327f9aa13cff2db8d31c1837e6a05753483b1df5c027'
AND (
token = '/ktEQZNZPMiLQFMACOlLZbBLq59mSU8UZ51P3a+JXMc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)