UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2hUayXsps7VA8EfAApohLk6wgeZdm6QsGF25xZXkBO8='
WHERE
key_id = 'c30f45317642e8512a3c936fb1ac414f0dc7697e88a057c6f31f54d34aafe84f'
AND (
token = '2hUayXsps7VA8EfAApohLk6wgeZdm6QsGF25xZXkBO8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)