UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6CsK7bpohQKP4vw+/ivzaM9Zsbj6ZoSeevtJGKlkOb4='
WHERE
key_id = '97b58f91bcf2d92ca307c816b8dd181ec2b2cb6edc0077885a37e4cd43f3a59c'
AND (
token = '6CsK7bpohQKP4vw+/ivzaM9Zsbj6ZoSeevtJGKlkOb4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)