UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/lsO8VyQpBcXtMC2nurD0X+FA4tE5LNM7fLnGAsx/pw='
WHERE
key_id = '7c3499f68a34ab82595cf1e4d1d3b16c50450f93a11c8c786ad0386079e3923a'
AND (
token = '/lsO8VyQpBcXtMC2nurD0X+FA4tE5LNM7fLnGAsx/pw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)