UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kzNAK0h9p32q2M7AyV12eWOu3KjY9UKfbtWGFlwPmH8='
WHERE
key_id = '71c5b0072e9cdb7252d2f1f6fe28d5346afc6bbc24b07457048389f1b18f6ea9'
AND (
token = 'kzNAK0h9p32q2M7AyV12eWOu3KjY9UKfbtWGFlwPmH8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)