UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'csN4MJ2MSUt4ZhhbcxvFFcAXk4PFy3yuB50JsnYRirg='
WHERE
key_id = '99cd3668240c042c655c468049950c5f35793a247cfa93a04e7d6f93d8198a89'
AND (
token = 'csN4MJ2MSUt4ZhhbcxvFFcAXk4PFy3yuB50JsnYRirg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)