UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZqcidbZ7GrTnuI/A4n9tVLpvUPy10h8BxJcMKp113e4='
WHERE
key_id = '98e2e8d0d9763839cde791a9fa01f854001daa54b3229331b11da75bef7aa38c'
AND (
token = 'ZqcidbZ7GrTnuI/A4n9tVLpvUPy10h8BxJcMKp113e4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)