UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ukXEfuV2uZQvF15rZDQi4M3oshjeRqTOKyDVAhudjOY='
WHERE
key_id = '8c3d5145edd038e4b0aafa20d7c0d15efa7118d28ef3bc521182d8dd117d3ee2'
AND (
token = 'ukXEfuV2uZQvF15rZDQi4M3oshjeRqTOKyDVAhudjOY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)