UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aM5HBUMDMakvWDh72U7nxc8MCJtPTG5YpG8/395mSrc='
WHERE
key_id = 'add7487e42aaf2dd46d4abe160eae97d73978dbab52ae8cb7812a88d9429808b'
AND (
token = 'aM5HBUMDMakvWDh72U7nxc8MCJtPTG5YpG8/395mSrc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)