UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pIpUeW4RUTWJB7fOPvAJpVQVB1tktFvD6e2J3N1XBCY='
WHERE
key_id = '532f047408ec99daa10827be07b6b46a7a10342906c181188157b7b6f73efba0'
AND (
token = 'pIpUeW4RUTWJB7fOPvAJpVQVB1tktFvD6e2J3N1XBCY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)