UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4FVyxctp9JYTkC9oZRrI5NNZsYG1xfoTjLoWrZjQZA4='
WHERE
key_id = '30c1d897493c34460b4b18ed9e31c849d6ef6d735a800e90341d6be2891c0217'
AND (
token = '4FVyxctp9JYTkC9oZRrI5NNZsYG1xfoTjLoWrZjQZA4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)