UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oSYDlgeBE7tq7gsOx8SRNm+TBMlzdS7LiVtvKKVHgpo='
WHERE
key_id = '419f87aef2ce93b4e8fe649bc3ba0ff8f0908314935dccc1d1eb8b841eb578d1'
AND (
token = 'oSYDlgeBE7tq7gsOx8SRNm+TBMlzdS7LiVtvKKVHgpo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)