UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zq1BAfOB0AABzbbwlj8pncaqV+chl99KYGvNGbdnYdk='
WHERE
key_id = '42409d4f5a509eeaf71acf2118e8e3e6f6944d40e1ea9227d4b1bb583ed68aff'
AND (
token = 'zq1BAfOB0AABzbbwlj8pncaqV+chl99KYGvNGbdnYdk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)